UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dHTDCGnUHZ57UTpbwf05L0P6SJdQUtA84699w6jqiu4='
WHERE
key_id = '0e8f67c35cf4f3e2142d3155c4f4e1756fd0980e9d27f26a26393ee1a749b1a2'
AND (
token = 'dHTDCGnUHZ57UTpbwf05L0P6SJdQUtA84699w6jqiu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)