UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lt7uZ+zQ7kLn8tSlwO5katdC1TZ2TewSOL0cdFs9m0='
WHERE
key_id = '31933ce6221736e8992662dadf1189cf33759b29c5d474663897af341cbc05c3'
AND (
token = '8lt7uZ+zQ7kLn8tSlwO5katdC1TZ2TewSOL0cdFs9m0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)