UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sbqBWTSDAbqp7RfGugDB1wmNZQG1lqISrIlHbH7q4pM='
WHERE
key_id = 'cc31e8248b112326e4347d20db02022bc9ecc2c05d36a9f904eee02bbebb4fc1'
AND (
token = 'sbqBWTSDAbqp7RfGugDB1wmNZQG1lqISrIlHbH7q4pM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)