UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9JE4QSFVyHAtUj1jSj6J5aDodn24dqcr/CHvuH7LHDg='
WHERE
key_id = '4ae4c5de9b7f35f55db472ae46cf81487e930bd667a4ee14e9603342bd7d22d2'
AND (
token = '9JE4QSFVyHAtUj1jSj6J5aDodn24dqcr/CHvuH7LHDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)