UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjsXziMpqsDF0f57OefLtw6p2fqwRrnjS1VoJDH+his='
WHERE
key_id = '0687e9173f13b175bf01320d8fecc5b4a5f82df266a3d899057aa5e3e9025933'
AND (
token = 'hjsXziMpqsDF0f57OefLtw6p2fqwRrnjS1VoJDH+his='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)