UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'N4vsukLr8A9b5b4mrCvmfr4dZdIOWx0gW2QUjv7Yk3I=' 
WHERE 
  key_id = '078f5ceb28cce2bc504e9325da68687a02f6c23c5b0874702b9c18c8d37fe90a' 
  AND (
    token = 'N4vsukLr8A9b5b4mrCvmfr4dZdIOWx0gW2QUjv7Yk3I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023