UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RtYPkZtwbW6Q1D9OdMstKzxklo7cEMAis6tZXKw+e0o='
WHERE
key_id = '9700ae2f12db1b6505e56b0dc2e34247b403b90453ab4da49ac8cba57ee6471b'
AND (
token = 'RtYPkZtwbW6Q1D9OdMstKzxklo7cEMAis6tZXKw+e0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)