UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y8HqibqG4x1+e3fqbqZIzRSqBlPo8REro0s45D4KIPI='
WHERE
key_id = 'dfaeefa3e0c5261c6d72c99220166eb555ef9f05486e6b0fa05989eaaae498e1'
AND (
token = 'Y8HqibqG4x1+e3fqbqZIzRSqBlPo8REro0s45D4KIPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)