UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Abfas69tgGYH9CE8xEyoG7yclqZPV+NrRs8Gjf7Qmv4='
WHERE
key_id = 'd69f048c31c3f84d2ec62efc41e1402dfb4aa545dbe50f35abd79e9e9f5b19f5'
AND (
token = 'Abfas69tgGYH9CE8xEyoG7yclqZPV+NrRs8Gjf7Qmv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)