UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/qG48EvyIw2TyMkDUSFjRumBCoKxrWBsayJUHjBcTxY='
WHERE
key_id = '3c33548c0b04a683fcdbb240ebf4ea160d90970404c10dd8197ffdd9218de07b'
AND (
token = '/qG48EvyIw2TyMkDUSFjRumBCoKxrWBsayJUHjBcTxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)