UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2pKmGckDr2UNI/zV2jtwTHO9qHWiPifNzofjRkyEITI=' 
WHERE 
  key_id = 'd054cf9075ab794e33aa53d54da5add919c8ce75b941d2f1e4c49df111d903fc' 
  AND (
    token = '2pKmGckDr2UNI/zV2jtwTHO9qHWiPifNzofjRkyEITI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021