UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XdmtPhDBBaY1Hnw3rEFZgc4VF8K41OmPl+cdmBdc43w=' 
WHERE 
  key_id = '3cb6f063a6d52a64dd11ac5130435d6b10e2c9bf1656f5ce3083856a66a5bd87' 
  AND (
    token = 'XdmtPhDBBaY1Hnw3rEFZgc4VF8K41OmPl+cdmBdc43w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041