UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VPhqc4uSFr1unso7tOZ4r3LKOkjxyr8LkhdIhhp0fdk='
WHERE
key_id = 'd16b033480c2c783475b77363212b0da6fbba753cd664b4d67d0bc7d4f83b3b3'
AND (
token = 'VPhqc4uSFr1unso7tOZ4r3LKOkjxyr8LkhdIhhp0fdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)