UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9kOpi2WFlkSvCknkoW87wJzdE9aVCDHYRwZayJhamw='
WHERE
key_id = '13658c6990641cf8047678702d1e510cf32b39b52178d3f12cbc3e32266ad3f8'
AND (
token = 'E9kOpi2WFlkSvCknkoW87wJzdE9aVCDHYRwZayJhamw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)