UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vm+qS9JWs0fXdfWPycIuKpZUIQq4D75Cj8/sapRYw90='
WHERE
key_id = 'cc5059d974ec09f44589c64c2f98590325c4b298a8356bf5d78fc71b635f47a6'
AND (
token = 'vm+qS9JWs0fXdfWPycIuKpZUIQq4D75Cj8/sapRYw90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)