UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KB7zSD1RKTCEKbqSzC3IpgfXWCBbtwW5I+hMdt5ZVEY='
WHERE
key_id = '586a266cdea4e8a6dfb069a5de9b468de74a07f7cc9f5452aae70e73a9ebc654'
AND (
token = 'KB7zSD1RKTCEKbqSzC3IpgfXWCBbtwW5I+hMdt5ZVEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)