UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9xFYQaxcJXAt4l5m8BaYdxqSIP52CLvdp9eGx8QLRkQ='
WHERE
key_id = 'ffd873b99cdec24a97032e30f80927dee1476348f7c3a1fdd90be05a8f3f9b1e'
AND (
token = '9xFYQaxcJXAt4l5m8BaYdxqSIP52CLvdp9eGx8QLRkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)