UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AEIo2zMZ+EMS6lzOTt069pRnZNEsBaYtngUasXwTWug='
WHERE
key_id = 'b9a8428f4486ae4d4763423ef18cbe93fd4353a6fe8befdaced01b00421c0b2d'
AND (
token = 'AEIo2zMZ+EMS6lzOTt069pRnZNEsBaYtngUasXwTWug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)