UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2GZ+MIZZW/zGOn3dE7lQSfRF160c3m9oXAJlOUdloWE='
WHERE
key_id = '9f9d9d338976d5395ab1edb300c50b584d99f42a1cb7254ab5d1e9a2ff0b62b1'
AND (
token = '2GZ+MIZZW/zGOn3dE7lQSfRF160c3m9oXAJlOUdloWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)