UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4gRnPymaKiZQgmS6Y2Ayd9vRoStT24Qzgs7s/Bj9AQE='
WHERE
key_id = '80f7531f927ec24df645a8edd66537d9e98faa1f794f4d3786178541948ababe'
AND (
token = '4gRnPymaKiZQgmS6Y2Ayd9vRoStT24Qzgs7s/Bj9AQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)