UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TIHzg3JqWHUcYfHvXsK9vIV6h1kOHc3yUsieKJyqC1k='
WHERE
key_id = '6b7695b54d8145888be35357e244bcf2aa77314854a81c9d8f7a6d5cc24ffbe6'
AND (
token = 'TIHzg3JqWHUcYfHvXsK9vIV6h1kOHc3yUsieKJyqC1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)