UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hB8PilYn3TWqSMA4Vft6BBSH96XHKfGb1oYMNyJI8VU='
WHERE
key_id = '0be39997785fca5aa81cb333899dea94bca420d55fc22ca3de5a19f52bfefbf6'
AND (
token = 'hB8PilYn3TWqSMA4Vft6BBSH96XHKfGb1oYMNyJI8VU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)