UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZFTkkBN6kuKV2uSENgs+iIryLvH6oHyc/d6zR6mhqU='
WHERE
key_id = '7d048e41a6c765fc244be6d9d6433ce5ef219976a522294ddb02fc1e830ac0ce'
AND (
token = 'KZFTkkBN6kuKV2uSENgs+iIryLvH6oHyc/d6zR6mhqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)