UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HFMljSikGeWfMa96s/Li1R1M0HdnT8q0M0boKdDWB5E=' 
WHERE 
  key_id = 'd69d9fa3c1fe31aa828d131825c3f04fb3c1c656602bfc77b3d38709b0b1aa6a' 
  AND (
    token = 'HFMljSikGeWfMa96s/Li1R1M0HdnT8q0M0boKdDWB5E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043