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