UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xkJMK45izeic+f29MAYZXvcMco1XqumlGI4huI2stUs='
WHERE
key_id = 'ce44f31e0ee7922db81be24ea32ca33b5d69dc9764ca6b591b507f195251c84f'
AND (
token = 'xkJMK45izeic+f29MAYZXvcMco1XqumlGI4huI2stUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)