UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hdtmSxsMdI2erSKcYh0HnXOfANOCwe7mSgCHC/tE1bU='
WHERE
key_id = '48f3f92ed482310d0e15b5b3ec57f42f800978f0d02329e7da490039592009f0'
AND (
token = 'hdtmSxsMdI2erSKcYh0HnXOfANOCwe7mSgCHC/tE1bU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)