UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cesS8RP+xV+8q5tgUZLC5rA1yTtTI6yLy1/vghsiwok='
WHERE
key_id = '0d268324931eba5ced2d439eb72547f439c5dbf4d375b4f7c81d676dce339e33'
AND (
token = 'cesS8RP+xV+8q5tgUZLC5rA1yTtTI6yLy1/vghsiwok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)