UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2rY8rvdV5IDzksUjEh7N3a7TF4hRFRByfro2Uyb1hTM='
WHERE
key_id = 'ca687c1ad8c7e116195b029f7bd946d0c573478189a4ca216341ed14e68f6277'
AND (
token = '2rY8rvdV5IDzksUjEh7N3a7TF4hRFRByfro2Uyb1hTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)