UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ChMJeXfjtktBLvCLEcwKjMDYdOeVNRoYxGQqsa2+XBU='
WHERE
key_id = 'bf06d8c72d3fa5fcc1b585ee41584ff0a199738e7ed74454ed6547a6fc2ce785'
AND (
token = 'ChMJeXfjtktBLvCLEcwKjMDYdOeVNRoYxGQqsa2+XBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)