UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UKo4RyTT2L+4q1YpBWUTjZbhsMu9txo5572YQ+gO8Do='
WHERE
key_id = 'a1e2c584f77af1442535b2c8b3b444ceeeae9b4c6f4c2ce253a75d3ab53754f3'
AND (
token = 'UKo4RyTT2L+4q1YpBWUTjZbhsMu9txo5572YQ+gO8Do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)