UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GI/4cO/EuBtq23CviNQAxOZ+CUuWaQOpiwHTzCS0dXs=' 
WHERE 
  key_id = '3d37c4dfa2aa514f4b8c63a3d4e53ef4293ae2a456b6b6b1f1dba34f9a901697' 
  AND (
    token = 'GI/4cO/EuBtq23CviNQAxOZ+CUuWaQOpiwHTzCS0dXs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021