UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BUiez8T3dwZ+TmAfDmmj507jkhBbgbnAChSNwjlWHmU='
WHERE
key_id = '3cdcdd0ae5bed319fb1802229510f6b778a66f3fe75ac32aa8441667f46e9963'
AND (
token = 'BUiez8T3dwZ+TmAfDmmj507jkhBbgbnAChSNwjlWHmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)